﻿CREATE TABLE [dbo].[tblOrders]
(
	[OrderID] INT NOT NULL PRIMARY KEY IDENTITY(1000, 1), 
    [OrderCustomerName] VARCHAR(50) NOT NULL, 
    [OrderProduct] INT NOT NULL, 
    [OrderDate] DATE NOT NULL, 
    [OrderQuantity] INT NOT NULL, 
    [OrderState] VARCHAR(50) NOT NULL,
	CONSTRAINT [OrdersProductFK] FOREIGN KEY ([OrderProduct]) REFERENCES [dbo].[tblProduct]([ProductID])
)
